Full predicate coverage for testing SQL database queries
نویسندگان
چکیده
منابع مشابه
Full predicate coverage for testing SQL database queries
In the field of database applications a considerable part of the business logic is implemented using a semi-declarative language: the Structured Query Language (SQL). Because of the different semantics of SQL compared to other procedural languages, the conventional coverage criteria for testing are not directly applicable. This paper presents a criterion specifically tailored for SQL queries (S...
متن کاملStructural Coverage Criteria for Testing SQL Queries
Adequacy criteria provide an objective measurement of test quality. Although these criteria are a major research issue in software testing, little work has been specifically targeted towards the testing of database-driven applications. In this paper, two structural coverage criteria are provided for evaluating the adequacy of a test suite for SQL queries that retrieve information from the datab...
متن کاملDatabase Courseware: Animating SQL queries
The goal of this paper is to describe the development of animations and other automated courseware to support database curricula, as well as to elicit idas and suggestions from other educators in this area. Part of an NSF funded project (NSF grant number 0089412), current work has focused on the design and implmentation of animations concerning SQL concepts. The first section describes the proj...
متن کاملTesting Database Applications with SQL Semantics
Testing of database applications is crucial for ensuring high software quality as undetected faults can result in unrecoverable data corruption. The problem of database application testing can be broadly partitioned into the problems of test cases generation, test data preparation and test outcomes verification. Among the three problems, the problem of test cases generation directly affects the...
متن کاملDo You Know Sql? about Semantic Errors in Database Queries
We investigate classes of SQL queries which are syntactically correct, but certainly not intended, no matter for which task the query was written. For instance, queries that are contradictory, i.e. always return the empty set, are quite often written in exams of database courses. Current database management systems, e.g. Oracle, execute such queries without any warning. In this paper, we give s...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Software Testing, Verification and Reliability
سال: 2010
ISSN: 0960-0833
DOI: 10.1002/stvr.424